namespace EFCodeFirst
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    public partial class EXECUTE_REAL_RX_1_201810
    {
        public long? FACILITY_ID { get; set; }

        public long? PHYSICIAN_ID { get; set; }

        [StringLength(200)]
        public string RX_IDENT { get; set; }

        [StringLength(32)]
        public string PATIENT_TYPE_CODE { get; set; }

        [StringLength(200)]
        public string DEPARTMENT_IDENT { get; set; }

        public DateTime? RECORD_DATE { get; set; }

        public DateTime? SERVICE_START_DATE { get; set; }

        public DateTime? SERVICE_END_DATE { get; set; }

        [StringLength(20)]
        public string AUDIT_PHARMACIST_NAME { get; set; }

        [StringLength(20)]
        public string CHECK_PHARMACIST_NAME { get; set; }

        [Column(TypeName = "numeric")]
        public decimal? RX_TOTAL_COST { get; set; }

        [StringLength(20)]
        public string RX_TYPE { get; set; }

        [StringLength(1)]
        public string WARNING_YN { get; set; }

        [StringLength(20)]
        public string PATIENT_REP { get; set; }

        [StringLength(20)]
        public string PATIENT_REP_IDENT { get; set; }

        [StringLength(100)]
        public string RX_REGISTER_NO { get; set; }

        [StringLength(100)]
        public string HIN_PHYS_IDENT { get; set; }

        [StringLength(20)]
        public string PHYS_NAME { get; set; }

        [StringLength(160)]
        public string PHYS_CLASS { get; set; }

        [StringLength(50)]
        public string PATIENT_IDENT { get; set; }

        [StringLength(200)]
        public string PATIENT_CARD_NO { get; set; }

        [StringLength(200)]
        public string PATIENT_NAME { get; set; }

        public DateTime? PATIENT_DOB { get; set; }

        [StringLength(1)]
        public string PATIENT_GENDER { get; set; }

        public int? PATIENT_HEIGHT { get; set; }

        [Column(TypeName = "numeric")]
        public decimal? PATIENT_WEIGHT { get; set; }

        [StringLength(100)]
        public string PATIENT_MEDICAL_INSURANCE_TYPE { get; set; }

        [StringLength(100)]
        public string PATIENT_MEDICAL_INSURANCE_NO { get; set; }

        [StringLength(100)]
        public string DEPARTMENT_NAME { get; set; }

        public int? PREGNANCY_DAY { get; set; }

        [StringLength(50)]
        public string RX_ID_GUID { get; set; }

        public DateTime? ENTERED { get; set; }

        [StringLength(30)]
        public string ENTERED_BY { get; set; }

        public int? VERSION_NUM { get; set; }

        [StringLength(500)]
        public string RX_DIAGNOSIS_CODE_TYPE { get; set; }

        [StringLength(500)]
        public string RX_DIAGNOSIS_CODE_VALUE { get; set; }

        [StringLength(500)]
        public string RX_DIAGNOSIS_NAME { get; set; }

        [StringLength(100)]
        public string RX_HISTORY_DIAGNOSIS_YN { get; set; }

        [StringLength(1)]
        public string ABX_FLAG { get; set; }

        [StringLength(1)]
        public string INJECTION_FLAG { get; set; }

        [StringLength(1)]
        public string PATENT_FLAG { get; set; }

        [StringLength(1)]
        public string DRINK_FLAG { get; set; }

        public int? DRUG_COUNT { get; set; }

        public int? NATIONAL_BASIC_DRUG_COUNT { get; set; }

        public int? DRUG_GENERIC_COUNT { get; set; }

        [StringLength(500)]
        public string RX_DIAGNOSIS_NAME_ADMISSION { get; set; }

        [StringLength(500)]
        public string RX_DIAGNOSIS_NAME_DISCHARGE { get; set; }

        [StringLength(20)]
        public string RX_REVIEW_PROCESS_STATUS { get; set; }

        [StringLength(1)]
        public string RX_REVIEW_AUTO_STATUS { get; set; }

        [StringLength(1)]
        public string RX_REVIEW_MANUAL_STATUS { get; set; }

        [StringLength(1)]
        public string RX_REVIEW_FINAL_STATUS { get; set; }

        public int? RX_REVIEW_AUTO_SCORE { get; set; }

        public int? RX_REVIEW_MANUAL_SCORE { get; set; }

        public int? RX_REVIEW_FINAL_SCORE { get; set; }

        [StringLength(500)]
        public string RX_REVIEW_AUTO_IRRATIONAL_ITEMS { get; set; }

        [StringLength(500)]
        public string RX_REVIEW_MANUAL_IRRATIONAL_ITEMS { get; set; }

        [StringLength(500)]
        public string RX_REVIEW_FINAL_IRRATIONAL_ITEMS { get; set; }

        [StringLength(2000)]
        public string COMMENT { get; set; }

        public DateTime? REVIEWED { get; set; }

        [StringLength(30)]
        public string REVIEWED_BY { get; set; }

        [StringLength(20)]
        public string LIVER_DAMAGE { get; set; }

        [StringLength(20)]
        public string KIDNEY_DAMAGE { get; set; }

        [StringLength(32)]
        public string ETHNIC { get; set; }

        [StringLength(100)]
        public string SKIN_TEST_RESULT { get; set; }

        [StringLength(50)]
        public string BAR_CODE { get; set; }

        [StringLength(32)]
        public string PHARMACY_CODE { get; set; }

        [StringLength(1)]
        public string LACTATION_YN { get; set; }

        [StringLength(1)]
        public string CHARGED_YN { get; set; }

        public int? ABX_DRUG_COUNT { get; set; }

        [StringLength(1)]
        public string ABX_SPECIAL_YN { get; set; }

        [StringLength(1)]
        public string ABX_UNION_YN { get; set; }

        [StringLength(300)]
        public string RX_INVALID_REVIEW_LIST { get; set; }

        [StringLength(100)]
        public string BACTERIA_EXAMINATION { get; set; }

        [StringLength(1)]
        public string IS_CACL_INPATIENT_DAYS_YN { get; set; }

        public long? REAL_RX_ID { get; set; }

        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public long EXECUTE_RX_ID { get; set; }
    }
}
